Access forms via email

[lorenzo21]

Hello All:

I am extremely new to Access and really do not have a clue what I am doing. I am currently working on a database that we want to constantly update as we send out emails to members of our organization. I am able to create an email with my table fields visible, but I am wondering if there is a way to create a different form layout that will still update automatically.

Also, I am running into an issue whenever I send out the email one time and it gets filled out, my table populates, but when that same form is sent back out and adjusted, the table does not populate even after I refresh it and/or close it.

Does anyone have any suggestions or input (is what I am asking even possible)? I have seen some tutorials with people writing code, but again I am extremely new to this and that is something I have no experience with.

Any help would be greatly appreciated! Thank You!

[June7]

What email method are you using?

How is the table populated - with what info?

What do you mean by 'form is sent back out and adjusted'? Adjusted what?

[redbull]

Are you trying to keep track of emails being sent? or received?

If you are tracking sent emails, as long as they are being sent using code you could insert an append query to a table of any kind that would record whatever information you want.

For incoming mail, I have a sloppy solution and I'm sure someone else has a much more elegant(SP?) solution...

[burrina]

Why are you sending out form and not attachments? Have you Googled or looked in the forum for examples?

[ranman256]

I dont understand how you 'email a form'. An access form cannot be separated from the database.
How is the data coming to you?

[lorenzo21]

I have the tables set-up in Access and the Form is not being separated. There is an option to create an email while the table is open. When you do that, you have the option to select all the fields you want included, whether or not to have the responses update automatically and to send the form using infopath or standard email. The only thing is, the layout of my form is not like how I designed it. Is there a way to send my form, that I designed, to our Reps so they can fill it out and automatically populate?

The second question is, how can your table update when our Reps make changes to the original form sent. What we are working on is being tracked in stages, so the stage will need to update constantly. Right now, I can only get the information to populate into my table once and any other information adjusted/corrected is not synced with my table.

Sorry for the limited information, but again this is my first time on Access and everything I have learned is through the WWW.

[redbull]

Honestly it sounds like google doc forms would be way better suited for this.
Create a form, then send them the weblink to use it... as they fill it out it automatically updates the spreadsheet backend.. and then you can do whatever you want with the data.

[lorenzo21]

Will google docs allow me to create drop-down lists?

[June7]

Are you using Collect Data utility?

[lorenzo21]

June7, not sure, but hopefuly this helps out. If I cannot get the data to update each time it is sent, is there a way to share this form and have it update the table each time the record is updated?

[June7]

I've never used this utility, only tried to help forum members. Another thread actively working with https://www.accessforums.net/import-...ion-47999.html

As far as I know, Collect Data is supposed to allow the collection of new and edited data.

At this point, I can't even replicate transmitting records with the email. The Create E-mail option isn't available unless I have a table or query open or click on in Navigation pane.